package love.yuanmeng.guetcoalsystem.vo;
/*
 *   @Studio:CHJY · 源梦科技
 *   @Author:CHJY创幻
 *   @Ide:IntelliJ IDEA
 *   @Creation time:2021/10/13 22:23
 */

public class PropManagerVo {
    private String supplierName;
    private String uid;
    private String username;
    private String orderId;
    private String enterpriseId1;
    private String enterpriseId2;
    private String createDate;
    private String finishDate;
    private String status;
    private String propId;
    private String price;
    private String id;
    private String userid;
    private String supplyQuantity;
    private String calorificValue;
    private String unitPrice;
    private String sulfur;
    private String placeOrigin;
    private String freightUnitPrice;
    private String volatitleMatterDown;
    private String volatitleMatterUp;
    private String port;
    private String ashContent;
    private String waterContent;
    private String propstatus;
    private String coalstatus;
    private String createTime;
    private String evaluate;
    private String bondNumber;
/*

SELECT ut.*
FROM
(
SELECT e.supplier_name,u.id as uid,u.username, o.*, p.*
FROM guetcoal.prop p left join guetcoal.order o on o.prop_id=p.id
left join guetcoal.enterprise_info e on o.enterprise_id2=e.enterprise_id
left join guetcoal.user u on u.enterpriseid=e.enterprise_id
) ut
WHERE ut.userid=3

#WHERE u.id=p.userid and u.enterpriseid=e.enterprise_id and p.propstatus=0;



#propstatus=0（在挂）1（被摘下）2(售出)3（售完）4(下架)
 */


    public String getSupplierName() {
        return supplierName;
    }

    public void setSupplierName(String supplierName) {
        this.supplierName = supplierName;
    }

    public String getUid() {
        return uid;
    }

    public void setUid(String uid) {
        this.uid = uid;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getOrderId() {
        return orderId;
    }

    public void setOrderId(String orderId) {
        this.orderId = orderId;
    }

    public String getEnterpriseId1() {
        return enterpriseId1;
    }

    public void setEnterpriseId1(String enterpriseId1) {
        this.enterpriseId1 = enterpriseId1;
    }

    public String getEnterpriseId2() {
        return enterpriseId2;
    }

    public void setEnterpriseId2(String enterpriseId2) {
        this.enterpriseId2 = enterpriseId2;
    }

    public String getCreateDate() {
        return createDate;
    }

    public void setCreateDate(String createDate) {
        this.createDate = createDate;
    }

    public String getFinishDate() {
        return finishDate;
    }

    public void setFinishDate(String finishDate) {
        this.finishDate = finishDate;
    }

    public String getStatus() {
        return status;
    }

    public void setStatus(String status) {
        this.status = status;
    }

    public String getPropId() {
        return propId;
    }

    public void setPropId(String propId) {
        this.propId = propId;
    }

    public String getPrice() {
        return price;
    }

    public void setPrice(String price) {
        this.price = price;
    }

    public String getId() {
        return id;
    }

    public void setId(String id) {
        this.id = id;
    }

    public String getUserid() {
        return userid;
    }

    public void setUserid(String userid) {
        this.userid = userid;
    }

    public String getSupplyQuantity() {
        return supplyQuantity;
    }

    public void setSupplyQuantity(String supplyQuantity) {
        this.supplyQuantity = supplyQuantity;
    }

    public String getCalorificValue() {
        return calorificValue;
    }

    public void setCalorificValue(String calorificValue) {
        this.calorificValue = calorificValue;
    }

    public String getUnitPrice() {
        return unitPrice;
    }

    public void setUnitPrice(String unitPrice) {
        this.unitPrice = unitPrice;
    }

    public String getSulfur() {
        return sulfur;
    }

    public void setSulfur(String sulfur) {
        this.sulfur = sulfur;
    }

    public String getPlaceOrigin() {
        return placeOrigin;
    }

    public void setPlaceOrigin(String placeOrigin) {
        this.placeOrigin = placeOrigin;
    }

    public String getFreightUnitPrice() {
        return freightUnitPrice;
    }

    public void setFreightUnitPrice(String freightUnitPrice) {
        this.freightUnitPrice = freightUnitPrice;
    }

    public String getVolatitleMatterDown() {
        return volatitleMatterDown;
    }

    public void setVolatitleMatterDown(String volatitleMatterDown) {
        this.volatitleMatterDown = volatitleMatterDown;
    }

    public String getVolatitleMatterUp() {
        return volatitleMatterUp;
    }

    public void setVolatitleMatterUp(String volatitleMatterUp) {
        this.volatitleMatterUp = volatitleMatterUp;
    }

    public String getPort() {
        return port;
    }

    public void setPort(String port) {
        this.port = port;
    }

    public String getPropstatus() {
        return propstatus;
    }

    public void setPropstatus(String propstatus) {
        this.propstatus = propstatus;
    }

    public String getCoalstatus() {
        return coalstatus;
    }

    public void setCoalstatus(String coalstatus) {
        this.coalstatus = coalstatus;
    }



    public String getEvaluate() {
        return evaluate;
    }

    public void setEvaluate(String evaluate) {
        this.evaluate = evaluate;
    }

    public String getAshContent() {
        return ashContent;
    }

    public void setAshContent(String ashContent) {
        this.ashContent = ashContent;
    }

    public String getWaterContent() {
        return waterContent;
    }

    public void setWaterContent(String waterContent) {
        this.waterContent = waterContent;
    }

    public String getCreateTime() {
        return createTime;
    }

    public void setCreateTime(String createTime) {
        this.createTime = createTime;
    }

    public String getBondNumber() {
        return bondNumber;
    }

    public void setBondNumber(String bondNumber) {
        this.bondNumber = bondNumber;
    }
}
